How do I read a string > 255 chars in php/adodb?

I stumbled across this article, which may help: ADODB Varchar Limit Problem What it seems to suggest you try is: Change your column type from varchar to text In the select statement, stipulate a CAST for the column: i.e. : select CAST(MyColumn as text) as MyColumn The post cites the following two articles, which back up the above php.oregonstate.edu/manual/en/ref.mssql.... php.oregonstate.edu/manual/en/ref.mssql.... Hope this helps.

You can then glue the columns back together. You might need some special cases for when then string isn't actualy that long.

I don't have problems using ADODB in PHP to query MSSQL. I write queries in the following way: Execute("SELECT ..."); while (!$rs->EOF) { print $rs->fields'fieldname'; // further processing of row $rs->MoveNext(); // move to the next row }.

Check your whether you are using DISTINCT and GROUP BY statements, apparently "truncation occurs on text fields when using DISTINCT and GROUP BY statements because of the overhead of comparing variable length strings as opposed to fixed length strings". Link.

You're obviously quoting something. Care to include the link? – James Wiseman Dec 20 '10 at 16:41 I am and I provided the link on "Link" but here you go bytes.com/topic/php/answers/717087-text-... – proxyniayan Feb 17 at 13:04.

Try replace all "255" to "800" or "MAX" in drivers\adodb-mssql.inc. Or just cast it, not change to text datatype , text is deprecated.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.